How Yelp can Support a New Business

Purpose of the Project

Yelp is becoming a growing platform for digital marketing. In our current day and age, having a effective digital presence on the internet can be vital to the success of a business. Through the Yelp Dataset, we hope to be able to discover insights that will help a new business be successful in their environment. For this project, we will be specifically focusing on the city of Las Vegas and the Yelp data involved. The source of our data is Yelp Data Set.

Summary Statistics

The total number of restaurants reviewed on Yelp for Las Vegas is 18153. 255628 people tipped in Las Vegas and North Las Vegas. The average star rating of the restaurants in Las Vegas and North Las Vegas is 3.6754531. The most reviewed restaurant was Mon Ami Gabi. The summary data for price range(Min, 1st Quartile, Median, Mean, 3rd Quartile, Max, NA’s) is 1, 1, 2, 1.8098836, 2, 4, 6902.

Summary Table by Rating

The following summary table groups the data by star ratings and calculates the total number of checkins, tips and reviews. The star rating is arranged in ascending order. By arranging the data in this way we can know the summary about the various star-ratings.

Rating	Checkins	Tips	Reviews
1.0	1272	145	1397
1.5	12513	1373	8134
2.0	46172	4052	16332
2.5	188141	13528	53994
3.0	511429	33775	122801
3.5	1025875	72697	241564
4.0	1197592	87745	323649
4.5	476721	36549	152025
5.0	63995	5764	39800

The most number of checkins, tips, and reviews were at restaurants with rating 4.0. This means people reviews on Yelp mostly if they find the place is worth a 4.0 rating.

Map of Las Vegas Businesses

This map of Las Vegas shows the star rating of every single business on Yelp. The color designates the star rating for the business. It is intended to allow a user to zoom into a specific are and see if it is concentrated with a specific star rating. In the future, we will be attempting to create a shiny UI that allows users to see where there are 1-star, 2-star, 3-star, 4-star, and 5-star businesses. In a broad scope, the map shows that a majority of businesses in Las Vegas regardless of region is rated 4-star and 5-star

<<<<<<< HEAD

Map of Businesses with over 1000 Reviews

This map of Las Vegas is filtered by businesses with over 1000 reviews in Las Vegas. The total number of businesses with over 1000 reviews is 104 businesses. When a user clicks on a point, they will get information such as the name, number of check-ins, and the average star rating of the restaurant. We hope that this will give the user an idea of what the top businesses in Las Vegas according to Yelp would be. We chose the map so that users can see the vicinity or area with the top businesses.

Bar Chart of Price Ranges in Las Vegas

Above is a bar chart of the different price levels for businesses in the Las Vegas region. We included this to show prospective business owners on what the most common price level is for businesses in the area. This bar graph demonstrates that a majority of restaurants were in the $11-$30 range.

<<<<<<< HEAD

Scatter Plot of Check-Ins Versus Reviews

We wanted to find the correlation of people that were checking into the business and see if they were also leaving a review. We found that a majority of the people that checked in did not end up leaving a review. We wanted to include this to allow prospective businesses to see if running check-in promotions would increase the amount of positive reviews on their Yelp profile. >>>>>>> d94e941a3218cc6df04ec9baee3f45712a29bfeb

987e888db95c5d9351a56bdca7431352bdb991e0